{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["INSTRUCTIONS","TANF SAMPLE","VERIFICATION DOCUMENTS","VOC CALCULATOR","DATA MANAGER"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INSTRUCTIONS","index":0,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,2,10,14],[12,2,14,14],[1,1,1,15],[16,2,21,14]]}
[]
[null,"TANF WORK HOURS VERIFICATION/DOCUMENTATION CHECKLIST\nINSTRUCTIONS"]
[]
[null,null," Report and verify all activity hours for Primary and Secondary Activities.\n   ● Verification documents to be used for these activities are listed in the Verification Documents field.\n       - See TANF Sample Guide (ES-4305) for all Acceptable Verifications.  You may type the \n          Acceptable Verification method in the Verification Documents field if it is not already listed.\n   ● verifications received over the phone. \n       - Select Collateral Contact * option in the Verification Documents field.\n       - Enter information for the collateral contact in the corresponding fields."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null," Review Zero Hour Activities.\n   ● Verification Documents field should be left blank."]
[]
[]
[]
[null,null," KEEP IN MIND:\n   ● Do NOT send in doctor's statements, psych evaluations, employer contacts (ES-4306), BARI/BASI, log\n       notes, referral forms, lists, or worksheets. These should be kept in the paper or electronic file in case an\n       audit occurs.\n       - Provider reports should only be sent when the client has hours that can be applied to participation.\n   ● Use a Journal entry to note who the client is working with (employer, provider, doctor, or school) or what\n       their special circumstances may be (postpartum, counseling, why they cannot work, etc.).\n   ● If employed, ensure the Employment Detail page is updated with current information for the state report.\n       If it is not, provide the information to the Purple Team for them to update.\n   ● If more than 2 mandatory adults in the HH, place additional information on a separate checklist."]

{"sheet":"TANF SAMPLE","index":1,"n_rows":142,"n_cols":14,"rows_kept":142,"cut":false,"hidden":false,"merged":[[13,2,13,3],[13,5,13,6],[42,2,46,3],[11,2,11,3],[42,4,46,4],[42,5,42,6],[43,5,43,6],[44,5,44,6],[45,5,45,6],[46,5,46,6],[12,9,12,10],[9,2,9,3],[9,12,10,13],[10,2,10,3],[12,12,12,13],[1,2,1,13],[3,3,3,4],[3,12,3,13],[4,3,4,4],[4,12,4,13],[5,12,5,13],[6,2,6,3],[6,12,6,13],[7,2,7,3],[8,2,8,3],[8,12,8,13],[5,3,5,4],[107,2,111,3],[107,4,111,4],[107,5,107,6],[108,5,108,6],[109,5,109,6],[110,5,110,6],[75,11,75,13],[76,5,76,6],[76,11,76,13],[78,2,78,3],[78,5,78,6],[75,7,75,10],[141,5,141,6],[141,11,141,13],[76,7,76,10],[111,5,111,6],[141,7,141,10],[140,7,140,10],[140,11,140,13]]}
[]
[null,null,"TANF WORK HOURS VERIFICATION/DOCUMENTATION CHECKLIST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ES-4304   Rev. 10/21"]
[null,null,"SAMPLE SPECIALIST:",null,null,null,null,null,null,null,null,"CASE #"]
[null,null,"CAREER NAVIGATOR:",null,null,null,null,null,null,null,null,"CASE NAME:"]
[null,null,"ES PA:",null,null,null,null,null,null,null,null,"DATE:"]
[null,null,"HH Type on Sample Report:",null,null,null,null,null,null,null,null,"SAMPLE MO/YR:"]
[null,null,"HH Type after adjustment:"]
[null,null,"TEEN PARENT?",null,null,null,null,null,null,null,null,null,"VERIFIED WEEKLY HOURS:"]
[null,null,"CHILD UNDER 6?",null,null,null,null,null,null,null,null,null,{"$f":"IF(M7=\"\",0,IF(OR($M$7='VOC CALCULATOR'!$F$3,ISBLANK('VOC CALCULATOR'!$F$3)),(SUM(N43:N47,N108:N112)/('DATA MANAGER'!K9-$M$7+1)*7)+SUM(M43:M47,M108:M112)))","v":0}]
[null,null,"ACTIVE CC BLOCK?"]
[null,null,"PARTIAL MONTH OF TANF?"]
[null,null,null,null,null,null,null,null,null,"Enter AVG HOURS PER WEEK or MONTHLY HOURS.\nDo NOT use both.",null,null,"HOURS FOR KEES\nView Progress"]
[null,null,"CLIENT NAME\n(Last, First)",null,"CLIENT ID#","ACTIVITY",null,"BEGIN DATE","END DATE","AVG HOURS PER WEEK","MONTHLY HOURS","VERIFICATION\nDOCUMENTS","AVG HOURS PER WEEK","TOTAL HOURS PER MONTH"]
[]
[null,null,null,null,null,"ALCOHOL & OTHER DRUG ASSESSMENT & TREATMENT"]
[null,null,null,null,null,"ASSESSMENT"]
[null,null,null,null,null,"DISABILITY EMPLOYMENT SERVICES"]
[null,null,null,null,null,"DOMESTIC VIOLENCE / SEXUAL ASSAULT"]
[null,null,null,null,null,"EARLY HEAD START / HEAD START"]
[null,null,null,null,null,"EDUCATION DIRECTLY RELATED TO EMPLOYMENT"]
[null,null,null,null,null,"JOB SEARCH / JOB READINESS"]
[null,null,null,null,null,"JOB SKILLS TRAINING"]
[null,null,null,null,null,"KANSAS HEALTH PROFESSION OPPORTUNITY PROGRAM"]
[null,null,null,null,null,"WORK PROGRAM PENALTY"]
[null,null,null,null,null,"MENTAL HEALTH CARE"]
[null,null,null,null,null,"ON-THE-JOB TRAINING"]
[null,null,null,null,null,"PHYSICAL HEALTH CARE"]
[null,null,null,null,null,"MENTORING"]
[null,null,null,null,null,"PREVENTION & PROTECTION SERVICES"]
[null,null,null,null,null,"REFUGEE EMPLOYMENT SERVICES"]
[null,null,null,null,null,"SATISFACTORY ATTENDANCE AT SECONDARY SCHOOL OR IN A GED PROGRAM"]
[null,null,null,null,null,"SUBSIDIZED PRIVATE EMPLOYMENT"]
[null,null,null,null,null,"SUBSIDIZED PUBLIC EMPLOYMENT"]
[null,null,null,null,null,"SUPERVISED COMMUNITY SERVICE"]
[null,null,null,null,null,"TWO-PARENT PARENT RESPONSIBLE FOR CHILD CARE"]
[null,null,null,null,null,"UNSUBSIDIZED EMPLOYMENT"]
[null,null,null,null,null,"EMPLOYMENT SERVICES TRACKING"]
[null,null,null,null,null,"VOCATIONAL EDUCATION"]
[null,null,null,null,null,"WORK EXPERIENCE"]
[null,null,null,null,null,"WORKFORCE INVESTMENT ACT"]
[null,null,null,null,null,"NO ACTIVITY OPEN"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($M$7=\"\",0,IF(AND(F43=\"VOCATIONAL EDUCATION\",$M$7='VOC CALCULATOR'!$F$3),'VOC CALCULATOR'!$I$15,IF(AND(H43<$M$7,I43<$M$7),0,IF(AND(H43>'DATA MANAGER'!$K$9,I43>'DATA MANAGER'!$K$9),0,IF(F43=\"JOB SEARCH / JOB READINESS\",0,IF(AND(OR(F43=\"UNSUBSIDIZED EMPLOYMENT\",F43=\"SUBSIDIZED PRIVATE EMPLOYMENT\",F43=\"SUBSIDIZED PUBLIC EMPLOYMENT\"),$E$12=\"YES\",H43>=$M$7,I43>='DATA MANAGER'!$K$9),J43,MAX(0,IF(AND(H43<='TANF SAMPLE'!$M$7,I43>='DATA MANAGER'!$K$9),J43,\"0\"))))))))","v":0},{"$f":"IF(AND(F43=\"VOCATIONAL EDUCATION\",'VOC CALCULATOR'!$I$3=YES),('VOC CALCULATOR'!$J$3),IF($M$7=\"\",0,IF(AND(F43=\"VOCATIONAL EDUCATION\",$M$7='VOC CALCULATOR'!$F$3),'VOC CALCULATOR'!$J$15,IF(AND(H43<$M$7,I43<$M$7),0,IF(AND(H43>'DATA MANAGER'!$K$9,I43>'DATA MANAGER'!$K$9),0,IF(F43=\"JOB SEARCH / JOB READINESS\",(K43),IF(AND(OR(F43=\"UNSUBSIDIZED EMPLOYMENT\",F43=\"SUBSIDIZED PRIVATE EMPLOYMENT\",F43=\"SUBSIDIZED PUBLIC EMPLOYMENT\"),$E$12=\"YES\",I43>='DATA MANAGER'!$K$9),0,+MAX(0,IF(OR(H43<>$M$7,I43<>'DATA MANAGER'!$K$9),MAX((J43/7),(ROUND((J43/7),0)))*IF(AND(H43<=$M$7,I43>='DATA MANAGER'!$K$9),0,IF(AND(H43<=$M$7,I43<='DATA MANAGER'!$K$9),(I43-$M$7+1),IF(AND(H43>=$M$7,I43<='DATA MANAGER'!$K$9),(I43-H43+1),IF(AND(H43>=$M$7,I43>='DATA MANAGER'!$K$9),('DATA MANAGER'!$K$9-H43+1),\"NOT OK\"))))),K43))))))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($M$7=\"\",0,IF(AND(F44=\"VOCATIONAL EDUCATION\",$M$7='VOC CALCULATOR'!$F$3),'VOC CALCULATOR'!$I$15,IF(AND(H44<$M$7,I44<$M$7),0,IF(AND(H44>'DATA MANAGER'!$K$9,I44>'DATA MANAGER'!$K$9),0,IF(F44=\"JOB SEARCH / JOB READINESS\",0,IF(AND(OR(F44=\"UNSUBSIDIZED EMPLOYMENT\",F44=\"SUBSIDIZED PRIVATE EMPLOYMENT\",F44=\"SUBSIDIZED PUBLIC EMPLOYMENT\"),$E$12=\"YES\",H44>=$M$7,I44>='DATA MANAGER'!$K$9),J44,MAX(0,IF(AND(H44<='TANF SAMPLE'!$M$7,I44>='DATA MANAGER'!$K$9),J44,\"0\"))))))))","v":0},{"$f":"IF(AND(F44=\"VOCATIONAL EDUCATION\",'VOC CALCULATOR'!$I$3=YES),('VOC CALCULATOR'!$J$3),IF($M$7=\"\",0,IF(AND(F44=\"VOCATIONAL EDUCATION\",$M$7='VOC CALCULATOR'!$F$3),'VOC CALCULATOR'!$J$15,IF(AND(H44<$M$7,I44<$M$7),0,IF(AND(H44>'DATA MANAGER'!$K$9,I44>'DATA MANAGER'!$K$9),0,IF(F44=\"JOB SEARCH / JOB READINESS\",(K44),IF(AND(OR(F44=\"UNSUBSIDIZED EMPLOYMENT\",F44=\"SUBSIDIZED PRIVATE EMPLOYMENT\",F44=\"SUBSIDIZED PUBLIC EMPLOYMENT\"),$E$12=\"YES\",I44>='DATA MANAGER'!$K$9),0,+MAX(0,IF(OR(H44<>$M$7,I44<>'DATA MANAGER'!$K$9),MAX((J44/7),(ROUND((J44/7),0)))*IF(AND(H44<=$M$7,I44>='DATA MANAGER'!$K$9),0,IF(AND(H44<=$M$7,I44<='DATA MANAGER'!$K$9),(I44-$M$7+1),IF(AND(H44>=$M$7,I44<='DATA MANAGER'!$K$9),(I44-H44+1),IF(AND(H44>=$M$7,I44>='DATA MANAGER'!$K$9),('DATA MANAGER'!$K$9-H44+1),\"NOT OK\"))))),K44))))))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($M$7=\"\",0,IF(AND(F45=\"VOCATIONAL EDUCATION\",$M$7='VOC CALCULATOR'!$F$3),'VOC CALCULATOR'!$I$15,IF(AND(H45<$M$7,I45<$M$7),0,IF(AND(H45>'DATA MANAGER'!$K$9,I45>'DATA MANAGER'!$K$9),0,IF(F45=\"JOB SEARCH / JOB READINESS\",0,IF(AND(OR(F45=\"UNSUBSIDIZED EMPLOYMENT\",F45=\"SUBSIDIZED PRIVATE EMPLOYMENT\",F45=\"SUBSIDIZED PUBLIC EMPLOYMENT\"),$E$12=\"YES\",H45>=$M$7,I45>='DATA MANAGER'!$K$9),J45,MAX(0,IF(AND(H45<='TANF SAMPLE'!$M$7,I45>='DATA MANAGER'!$K$9),J45,\"0\"))))))))","v":0},{"$f":"IF(AND(F45=\"VOCATIONAL EDUCATION\",'VOC CALCULATOR'!$I$3=YES),('VOC CALCULATOR'!$J$3),IF($M$7=\"\",0,IF(AND(F45=\"VOCATIONAL EDUCATION\",$M$7='VOC CALCULATOR'!$F$3),'VOC CALCULATOR'!$J$15,IF(AND(H45<$M$7,I45<$M$7),0,IF(AND(H45>'DATA MANAGER'!$K$9,I45>'DATA MANAGER'!$K$9),0,IF(F45=\"JOB SEARCH / JOB READINESS\",(K45),IF(AND(OR(F45=\"UNSUBSIDIZED EMPLOYMENT\",F45=\"SUBSIDIZED PRIVATE EMPLOYMENT\",F45=\"SUBSIDIZED PUBLIC EMPLOYMENT\"),$E$12=\"YES\",I45>='DATA MANAGER'!$K$9),0,+MAX(0,IF(OR(H45<>$M$7,I45<>'DATA MANAGER'!$K$9),MAX((J45/7),(ROUND((J45/7),0)))*IF(AND(H45<=$M$7,I45>='DATA MANAGER'!$K$9),0,IF(AND(H45<=$M$7,I45<='DATA MANAGER'!$K$9),(I45-$M$7+1),IF(AND(H45>=$M$7,I45<='DATA MANAGER'!$K$9),(I45-H45+1),IF(AND(H45>=$M$7,I45>='DATA MANAGER'!$K$9),('DATA MANAGER'!$K$9-H45+1),\"NOT OK\"))))),K45))))))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($M$7=\"\",0,IF(AND(F46=\"VOCATIONAL EDUCATION\",$M$7='VOC CALCULATOR'!$F$3),'VOC CALCULATOR'!$I$15,IF(AND(H46<$M$7,I46<$M$7),0,IF(AND(H46>'DATA MANAGER'!$K$9,I46>'DATA MANAGER'!$K$9),0,IF(F46=\"JOB SEARCH / JOB READINESS\",0,IF(AND(OR(F46=\"UNSUBSIDIZED EMPLOYMENT\",F46=\"SUBSIDIZED PRIVATE EMPLOYMENT\",F46=\"SUBSIDIZED PUBLIC EMPLOYMENT\"),$E$12=\"YES\",H46>=$M$7,I46>='DATA MANAGER'!$K$9),J46,MAX(0,IF(AND(H46<='TANF SAMPLE'!$M$7,I46>='DATA MANAGER'!$K$9),J46,\"0\"))))))))","v":0},{"$f":"IF(AND(F46=\"VOCATIONAL EDUCATION\",'VOC CALCULATOR'!$I$3=YES),('VOC CALCULATOR'!$J$3),IF($M$7=\"\",0,IF(AND(F46=\"VOCATIONAL EDUCATION\",$M$7='VOC CALCULATOR'!$F$3),'VOC CALCULATOR'!$J$15,IF(AND(H46<$M$7,I46<$M$7),0,IF(AND(H46>'DATA MANAGER'!$K$9,I46>'DATA MANAGER'!$K$9),0,IF(F46=\"JOB SEARCH / JOB READINESS\",(K46),IF(AND(OR(F46=\"UNSUBSIDIZED EMPLOYMENT\",F46=\"SUBSIDIZED PRIVATE EMPLOYMENT\",F46=\"SUBSIDIZED PUBLIC EMPLOYMENT\"),$E$12=\"YES\",I46>='DATA MANAGER'!$K$9),0,+MAX(0,IF(OR(H46<>$M$7,I46<>'DATA MANAGER'!$K$9),MAX((J46/7),(ROUND((J46/7),0)))*IF(AND(H46<=$M$7,I46>='DATA MANAGER'!$K$9),0,IF(AND(H46<=$M$7,I46<='DATA MANAGER'!$K$9),(I46-$M$7+1),IF(AND(H46>=$M$7,I46<='DATA MANAGER'!$K$9),(I46-H46+1),IF(AND(H46>=$M$7,I46>='DATA MANAGER'!$K$9),('DATA MANAGER'!$K$9-H46+1),\"NOT OK\"))))),K46))))))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($M$7=\"\",0,IF(AND(F47=\"VOCATIONAL EDUCATION\",$M$7='VOC CALCULATOR'!$F$3),'VOC CALCULATOR'!$I$15,IF(AND(H47<$M$7,I47<$M$7),0,IF(AND(H47>'DATA MANAGER'!$K$9,I47>'DATA MANAGER'!$K$9),0,IF(F47=\"JOB SEARCH / JOB READINESS\",0,IF(AND(OR(F47=\"UNSUBSIDIZED EMPLOYMENT\",F47=\"SUBSIDIZED PRIVATE EMPLOYMENT\",F47=\"SUBSIDIZED PUBLIC EMPLOYMENT\"),$E$12=\"YES\",H47>=$M$7,I47>='DATA MANAGER'!$K$9),J47,MAX(0,IF(AND(H47<='TANF SAMPLE'!$M$7,I47>='DATA MANAGER'!$K$9),J47,\"0\"))))))))","v":0},{"$f":"IF(AND(F47=\"VOCATIONAL EDUCATION\",'VOC CALCULATOR'!$I$3=YES),('VOC CALCULATOR'!$J$3),IF($M$7=\"\",0,IF(AND(F47=\"VOCATIONAL EDUCATION\",$M$7='VOC CALCULATOR'!$F$3),'VOC CALCULATOR'!$J$15,IF(AND(H47<$M$7,I47<$M$7),0,IF(AND(H47>'DATA MANAGER'!$K$9,I47>'DATA MANAGER'!$K$9),0,IF(F47=\"JOB SEARCH / JOB READINESS\",(K47),IF(AND(OR(F47=\"UNSUBSIDIZED EMPLOYMENT\",F47=\"SUBSIDIZED PRIVATE EMPLOYMENT\",F47=\"SUBSIDIZED PUBLIC EMPLOYMENT\"),$E$12=\"YES\",I47>='DATA MANAGER'!$K$9),0,+MAX(0,IF(OR(H47<>$M$7,I47<>'DATA MANAGER'!$K$9),MAX((J47/7),(ROUND((J47/7),0)))*IF(AND(H47<=$M$7,I47>='DATA MANAGER'!$K$9),0,IF(AND(H47<=$M$7,I47<='DATA MANAGER'!$K$9),(I47-$M$7+1),IF(AND(H47>=$M$7,I47<='DATA MANAGER'!$K$9),(I47-H47+1),IF(AND(H47>=$M$7,I47>='DATA MANAGER'!$K$9),('DATA MANAGER'!$K$9-H47+1),\"NOT OK\"))))),K47))))))))","v":0}]
[]
[null,null,null,null,null,null,null,"ALCOHOL & OTHER DRUG ASSESSMENT & TREATMENT"]
[null,null,null,null,null,null,null,"ASSESSMENT"]
[null,null,null,null,null,null,null,"DISABILITY EMPLOYMENT SERVICES"]
[null,null,null,null,null,null,null,"DOMESTIC VIOLENCE / SEXUAL ASSAULT"]
[null,null,null,null,null,null,null,"EARLY HEAD START / HEAD START"]
[null,null,null,null,null,null,null,"EDUCATION DIRECTLY RELATED TO EMPLOYMENT"]
[null,null,null,null,null,null,null,"JOB SEARCH / JOB READINESS"]
[null,null,null,null,null,null,null,"JOB SKILLS TRAINING"]
[null,null,null,null,null,null,null,"KANSAS HEALTH PROFESSION OPPORTUNITY PROGRAM"]
[null,null,null,null,null,null,null,"WORK PROGRAM PENALTY"]
[null,null,null,null,null,null,null,"MENTAL HEALTH CARE"]
[null,null,null,null,null,null,null,"ON-THE-JOB TRAINING"]
[null,null,null,null,null,null,null,"PHYSICAL HEALTH CARE"]
[null,null,null,null,null,null,null,"MENTORING"]
[null,null,null,null,null,null,null,"PREVENTION & PROTECTION SERVICES"]
[null,null,null,null,null,null,null,"REFUGEE EMPLOYMENT SERVICES"]
[null,null,null,null,null,null,null,"SATISFACTORY ATTENDANCE AT SECONDARY SCHOOL OR IN A GED PROGRAM"]
[null,null,null,null,null,null,null,"SUBSIDIZED PRIVATE EMPLOYMENT"]
[null,null,null,null,null,null,null,"SUBSIDIZED PUBLIC EMPLOYMENT"]
[null,null,null,null,null,null,null,"SUPERVISED COMMUNITY SERVICE"]
[null,null,null,null,null,null,null,"TWO-PARENT PARENT RESPONSIBLE FOR CHILD CARE"]
[null,null,null,null,null,null,null,"UNSUBSIDIZED EMPLOYMENT"]
[null,null,null,null,null,null,null,"EMPLOYMENT SERVICES TRACKING"]
[null,null,null,null,null,null,null,"VOCATIONAL EDUCATION"]
[null,null,null,null,null,null,null,"WORK EXPERIENCE"]
[null,null,null,null,null,null,null,"WORKFORCE INVESTMENT ACT"]
[null,null,null,null,null,null,null,"NO ACTIVITY OPEN"]
[null,null,null,null,null,null,null,"ACTIVITY",null,null,null,"NAME, PHONE #, TITLE/POSITION, AGENCY"]
[null,null,null,null,null,"*If Collateral Contact is used, enter Contact Info:"]
[]
[null,null,"CLIENT NAME\n(Last, First)",null,"CLIENT ID#","ACTIVITY",null,"BEGIN DATE","END DATE","AVG HOURS PER WEEK","MONTHLY HOURS","VERIFICATION\nDOCUMENTS","AVG HOURS PER WEEK","TOTAL HOURS PER MONTH"]
[]
[null,null,null,null,null,"ALCOHOL & OTHER DRUG ASSESSMENT & TREATMENT"]
[null,null,null,null,null,"ASSESSMENT"]
[null,null,null,null,null,"DISABILITY EMPLOYMENT SERVICES"]
[null,null,null,null,null,"DOMESTIC VIOLENCE / SEXUAL ASSAULT"]
[null,null,null,null,null,"EARLY HEAD START / HEAD START"]
[null,null,null,null,null,"EDUCATION DIRECTLY RELATED TO EMPLOYMENT"]
[null,null,null,null,null,"JOB SEARCH / JOB READINESS"]
[null,null,null,null,null,"JOB SKILLS TRAINING"]
[null,null,null,null,null,"KANSAS HEALTH PROFESSION OPPORTUNITY PROGRAM"]
[null,null,null,null,null,"WORK PROGRAM PENALTY"]
[null,null,null,null,null,"MENTAL HEALTH CARE"]
[null,null,null,null,null,"ON-THE-JOB TRAINING"]
[null,null,null,null,null,"PHYSICAL HEALTH CARE"]
[null,null,null,null,null,"MENTORING"]
[null,null,null,null,null,"PREVENTION & PROTECTION SERVICES"]
[null,null,null,null,null,"REFUGEE EMPLOYMENT SERVICES"]
[null,null,null,null,null,"SATISFACTORY ATTENDANCE AT SECONDARY SCHOOL OR IN A GED PROGRAM"]
[null,null,null,null,null,"SUBSIDIZED PRIVATE EMPLOYMENT"]
[null,null,null,null,null,"SUBSIDIZED PUBLIC EMPLOYMENT"]
[null,null,null,null,null,"SUPERVISED COMMUNITY SERVICE"]
[null,null,null,null,null,"TWO-PARENT PARENT RESPONSIBLE FOR CHILD CARE"]
[null,null,null,null,null,"UNSUBSIDIZED EMPLOYMENT"]
[null,null,null,null,null,"EMPLOYMENT SERVICES TRACKING"]
[null,null,null,null,null,"VOCATIONAL EDUCATION"]
[null,null,null,null,null,"WORK EXPERIENCE"]
[null,null,null,null,null,"WORKFORCE INVESTMENT ACT"]
[null,null,null,null,null,"NO ACTIVITY OPEN"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($M$7=\"\",0,IF(AND(F108=\"VOCATIONAL EDUCATION\",$M$7='VOC CALCULATOR'!$F$3),'VOC CALCULATOR'!$I$28,IF(AND(H108<$M$7,I108<$M$7),0,IF(AND(H108>'DATA MANAGER'!$K$9,I108>'DATA MANAGER'!$K$9),0,IF(F108=\"JOB SEARCH / JOB READINESS\",0,IF(AND(OR(F108=\"UNSUBSIDIZED EMPLOYMENT\",F108=\"SUBSIDIZED PRIVATE EMPLOYMENT\",F108=\"SUBSIDIZED PUBLIC EMPLOYMENT\"),$E$12=\"YES\",H108>=$M$7,I108>='DATA MANAGER'!$K$9),J108,MAX(0,IF(AND(H108<='TANF SAMPLE'!$M$7,I108>='DATA MANAGER'!$K$9),J108,\"0\"))))))))","v":0},{"$f":"IF(AND(F108=\"VOCATIONAL EDUCATION\",'VOC CALCULATOR'!$I$20=YES),('VOC CALCULATOR'!$J$20),IF($M$7=\"\",0,IF(AND(F108=\"VOCATIONAL EDUCATION\",$M$7='VOC CALCULATOR'!$F$3),'VOC CALCULATOR'!$J$28,IF(AND(H108<$M$7,I108<$M$7),0,IF(AND(H108>'DATA MANAGER'!$K$9,I108>'DATA MANAGER'!$K$9),0,IF(F108=\"JOB SEARCH / JOB READINESS\",(K108),IF(AND(OR(F108=\"UNSUBSIDIZED EMPLOYMENT\",F108=\"SUBSIDIZED PRIVATE EMPLOYMENT\",F108=\"SUBSIDIZED PUBLIC EMPLOYMENT\"),$E$12=\"YES\",I108>='DATA MANAGER'!$K$9),0,+MAX(0,IF(OR(H108<>$M$7,I108<>'DATA MANAGER'!$K$9),MAX((J108/7),(ROUND((J108/7),0)))*IF(AND(H108<=$M$7,I108>='DATA MANAGER'!$K$9),0,IF(AND(H108<=$M$7,I108<='DATA MANAGER'!$K$9),(I108-$M$7+1),IF(AND(H108>=$M$7,I108<='DATA MANAGER'!$K$9),(I108-H108+1),IF(AND(H108>=$M$7,I108>='DATA MANAGER'!$K$9),('DATA MANAGER'!$K$9-H108+1),\"NOT OK\"))))),K108))))))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($M$7=\"\",0,IF(AND(F109=\"VOCATIONAL EDUCATION\",$M$7='VOC CALCULATOR'!$F$3),'VOC CALCULATOR'!$I$28,IF(AND(H109<$M$7,I109<$M$7),0,IF(AND(H109>'DATA MANAGER'!$K$9,I109>'DATA MANAGER'!$K$9),0,IF(F109=\"JOB SEARCH / JOB READINESS\",0,IF(AND(OR(F109=\"UNSUBSIDIZED EMPLOYMENT\",F109=\"SUBSIDIZED PRIVATE EMPLOYMENT\",F109=\"SUBSIDIZED PUBLIC EMPLOYMENT\"),$E$12=\"YES\",H109>=$M$7,I109>='DATA MANAGER'!$K$9),J109,MAX(0,IF(AND(H109<='TANF SAMPLE'!$M$7,I109>='DATA MANAGER'!$K$9),J109,\"0\"))))))))","v":0},{"$f":"IF(AND(F109=\"VOCATIONAL EDUCATION\",'VOC CALCULATOR'!$I$20=YES),('VOC CALCULATOR'!$J$20),IF($M$7=\"\",0,IF(AND(F109=\"VOCATIONAL EDUCATION\",$M$7='VOC CALCULATOR'!$F$3),'VOC CALCULATOR'!$J$28,IF(AND(H109<$M$7,I109<$M$7),0,IF(AND(H109>'DATA MANAGER'!$K$9,I109>'DATA MANAGER'!$K$9),0,IF(F109=\"JOB SEARCH / JOB READINESS\",(K109),IF(AND(OR(F109=\"UNSUBSIDIZED EMPLOYMENT\",F109=\"SUBSIDIZED PRIVATE EMPLOYMENT\",F109=\"SUBSIDIZED PUBLIC EMPLOYMENT\"),$E$12=\"YES\",I109>='DATA MANAGER'!$K$9),0,+MAX(0,IF(OR(H109<>$M$7,I109<>'DATA MANAGER'!$K$9),MAX((J109/7),(ROUND((J109/7),0)))*IF(AND(H109<=$M$7,I109>='DATA MANAGER'!$K$9),0,IF(AND(H109<=$M$7,I109<='DATA MANAGER'!$K$9),(I109-$M$7+1),IF(AND(H109>=$M$7,I109<='DATA MANAGER'!$K$9),(I109-H109+1),IF(AND(H109>=$M$7,I109>='DATA MANAGER'!$K$9),('DATA MANAGER'!$K$9-H109+1),\"NOT OK\"))))),K109))))))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($M$7=\"\",0,IF(AND(F110=\"VOCATIONAL EDUCATION\",$M$7='VOC CALCULATOR'!$F$3),'VOC CALCULATOR'!$I$28,IF(AND(H110<$M$7,I110<$M$7),0,IF(AND(H110>'DATA MANAGER'!$K$9,I110>'DATA MANAGER'!$K$9),0,IF(F110=\"JOB SEARCH / JOB READINESS\",0,IF(AND(OR(F110=\"UNSUBSIDIZED EMPLOYMENT\",F110=\"SUBSIDIZED PRIVATE EMPLOYMENT\",F110=\"SUBSIDIZED PUBLIC EMPLOYMENT\"),$E$12=\"YES\",H110>=$M$7,I110>='DATA MANAGER'!$K$9),J110,MAX(0,IF(AND(H110<='TANF SAMPLE'!$M$7,I110>='DATA MANAGER'!$K$9),J110,\"0\"))))))))","v":0},{"$f":"IF(AND(F110=\"VOCATIONAL EDUCATION\",'VOC CALCULATOR'!$I$20=YES),('VOC CALCULATOR'!$J$20),IF($M$7=\"\",0,IF(AND(F110=\"VOCATIONAL EDUCATION\",$M$7='VOC CALCULATOR'!$F$3),'VOC CALCULATOR'!$J$28,IF(AND(H110<$M$7,I110<$M$7),0,IF(AND(H110>'DATA MANAGER'!$K$9,I110>'DATA MANAGER'!$K$9),0,IF(F110=\"JOB SEARCH / JOB READINESS\",(K110),IF(AND(OR(F110=\"UNSUBSIDIZED EMPLOYMENT\",F110=\"SUBSIDIZED PRIVATE EMPLOYMENT\",F110=\"SUBSIDIZED PUBLIC EMPLOYMENT\"),$E$12=\"YES\",I110>='DATA MANAGER'!$K$9),0,+MAX(0,IF(OR(H110<>$M$7,I110<>'DATA MANAGER'!$K$9),MAX((J110/7),(ROUND((J110/7),0)))*IF(AND(H110<=$M$7,I110>='DATA MANAGER'!$K$9),0,IF(AND(H110<=$M$7,I110<='DATA MANAGER'!$K$9),(I110-$M$7+1),IF(AND(H110>=$M$7,I110<='DATA MANAGER'!$K$9),(I110-H110+1),IF(AND(H110>=$M$7,I110>='DATA MANAGER'!$K$9),('DATA MANAGER'!$K$9-H110+1),\"NOT OK\"))))),K110))))))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($M$7=\"\",0,IF(AND(F111=\"VOCATIONAL EDUCATION\",$M$7='VOC CALCULATOR'!$F$3),'VOC CALCULATOR'!$I$28,IF(AND(H111<$M$7,I111<$M$7),0,IF(AND(H111>'DATA MANAGER'!$K$9,I111>'DATA MANAGER'!$K$9),0,IF(F111=\"JOB SEARCH / JOB READINESS\",0,IF(AND(OR(F111=\"UNSUBSIDIZED EMPLOYMENT\",F111=\"SUBSIDIZED PRIVATE EMPLOYMENT\",F111=\"SUBSIDIZED PUBLIC EMPLOYMENT\"),$E$12=\"YES\",H111>=$M$7,I111>='DATA MANAGER'!$K$9),J111,MAX(0,IF(AND(H111<='TANF SAMPLE'!$M$7,I111>='DATA MANAGER'!$K$9),J111,\"0\"))))))))","v":0},{"$f":"IF(AND(F111=\"VOCATIONAL EDUCATION\",'VOC CALCULATOR'!$I$20=YES),('VOC CALCULATOR'!$J$20),IF($M$7=\"\",0,IF(AND(F111=\"VOCATIONAL EDUCATION\",$M$7='VOC CALCULATOR'!$F$3),'VOC CALCULATOR'!$J$28,IF(AND(H111<$M$7,I111<$M$7),0,IF(AND(H111>'DATA MANAGER'!$K$9,I111>'DATA MANAGER'!$K$9),0,IF(F111=\"JOB SEARCH / JOB READINESS\",(K111),IF(AND(OR(F111=\"UNSUBSIDIZED EMPLOYMENT\",F111=\"SUBSIDIZED PRIVATE EMPLOYMENT\",F111=\"SUBSIDIZED PUBLIC EMPLOYMENT\"),$E$12=\"YES\",I111>='DATA MANAGER'!$K$9),0,+MAX(0,IF(OR(H111<>$M$7,I111<>'DATA MANAGER'!$K$9),MAX((J111/7),(ROUND((J111/7),0)))*IF(AND(H111<=$M$7,I111>='DATA MANAGER'!$K$9),0,IF(AND(H111<=$M$7,I111<='DATA MANAGER'!$K$9),(I111-$M$7+1),IF(AND(H111>=$M$7,I111<='DATA MANAGER'!$K$9),(I111-H111+1),IF(AND(H111>=$M$7,I111>='DATA MANAGER'!$K$9),('DATA MANAGER'!$K$9-H111+1),\"NOT OK\"))))),K111))))))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($M$7=\"\",0,IF(AND(F112=\"VOCATIONAL EDUCATION\",$M$7='VOC CALCULATOR'!$F$3),'VOC CALCULATOR'!$I$28,IF(AND(H112<$M$7,I112<$M$7),0,IF(AND(H112>'DATA MANAGER'!$K$9,I112>'DATA MANAGER'!$K$9),0,IF(F112=\"JOB SEARCH / JOB READINESS\",0,IF(AND(OR(F112=\"UNSUBSIDIZED EMPLOYMENT\",F112=\"SUBSIDIZED PRIVATE EMPLOYMENT\",F112=\"SUBSIDIZED PUBLIC EMPLOYMENT\"),$E$12=\"YES\",H112>=$M$7,I112>='DATA MANAGER'!$K$9),J112,MAX(0,IF(AND(H112<='TANF SAMPLE'!$M$7,I112>='DATA MANAGER'!$K$9),J112,\"0\"))))))))","v":0},{"$f":"IF(AND(F112=\"VOCATIONAL EDUCATION\",'VOC CALCULATOR'!$I$20=YES),('VOC CALCULATOR'!$J$20),IF($M$7=\"\",0,IF(AND(F112=\"VOCATIONAL EDUCATION\",$M$7='VOC CALCULATOR'!$F$3),'VOC CALCULATOR'!$J$28,IF(AND(H112<$M$7,I112<$M$7),0,IF(AND(H112>'DATA MANAGER'!$K$9,I112>'DATA MANAGER'!$K$9),0,IF(F112=\"JOB SEARCH / JOB READINESS\",(K112),IF(AND(OR(F112=\"UNSUBSIDIZED EMPLOYMENT\",F112=\"SUBSIDIZED PRIVATE EMPLOYMENT\",F112=\"SUBSIDIZED PUBLIC EMPLOYMENT\"),$E$12=\"YES\",I112>='DATA MANAGER'!$K$9),0,+MAX(0,IF(OR(H112<>$M$7,I112<>'DATA MANAGER'!$K$9),MAX((J112/7),(ROUND((J112/7),0)))*IF(AND(H112<=$M$7,I112>='DATA MANAGER'!$K$9),0,IF(AND(H112<=$M$7,I112<='DATA MANAGER'!$K$9),(I112-$M$7+1),IF(AND(H112>=$M$7,I112<='DATA MANAGER'!$K$9),(I112-H112+1),IF(AND(H112>=$M$7,I112>='DATA MANAGER'!$K$9),('DATA MANAGER'!$K$9-H112+1),\"NOT OK\"))))),K112))))))))","v":0}]
[]
[null,null,null,null,null,null,null,"ALCOHOL & OTHER DRUG ASSESSMENT & TREATMENT"]
[null,null,null,null,null,null,null,"ASSESSMENT"]
[null,null,null,null,null,null,null,"DISABILITY EMPLOYMENT SERVICES"]
[null,null,null,null,null,null,null,"DOMESTIC VIOLENCE / SEXUAL ASSAULT"]
[null,null,null,null,null,null,null,"EARLY HEAD START / HEAD START"]
[null,null,null,null,null,null,null,"EDUCATION DIRECTLY RELATED TO EMPLOYMENT"]
[null,null,null,null,null,null,null,"JOB SEARCH / JOB READINESS"]
[null,null,null,null,null,null,null,"JOB SKILLS TRAINING"]
[null,null,null,null,null,null,null,"KANSAS HEALTH PROFESSION OPPORTUNITY PROGRAM"]
[null,null,null,null,null,null,null,"WORK PROGRAM PENALTY"]
[null,null,null,null,null,null,null,"MENTAL HEALTH CARE"]
[null,null,null,null,null,null,null,"ON-THE-JOB TRAINING"]
[null,null,null,null,null,null,null,"PHYSICAL HEALTH CARE"]
[null,null,null,null,null,null,null,"MENTORING"]
[null,null,null,null,null,null,null,"PREVENTION & PROTECTION SERVICES"]
[null,null,null,null,null,null,null,"REFUGEE EMPLOYMENT SERVICES"]
[null,null,null,null,null,null,null,"SATISFACTORY ATTENDANCE AT SECONDARY SCHOOL OR IN A GED PROGRAM"]
[null,null,null,null,null,null,null,"SUBSIDIZED PRIVATE EMPLOYMENT"]
[null,null,null,null,null,null,null,"SUBSIDIZED PUBLIC EMPLOYMENT"]
[null,null,null,null,null,null,null,"SUPERVISED COMMUNITY SERVICE"]
[null,null,null,null,null,null,null,"TWO-PARENT PARENT RESPONSIBLE FOR CHILD CARE"]
[null,null,null,null,null,null,null,"UNSUBSIDIZED EMPLOYMENT"]
[null,null,null,null,null,null,null,"EMPLOYMENT SERVICES TRACKING"]
[null,null,null,null,null,null,null,"VOCATIONAL EDUCATION"]
[null,null,null,null,null,null,null,"WORK EXPERIENCE"]
[null,null,null,null,null,null,null,"WORKFORCE INVESTMENT ACT"]
[null,null,null,null,null,null,null,"NO ACTIVITY OPEN"]
[null,null,null,null,null,null,null,"ACTIVITY",null,null,null,"NAME, PHONE #, TITLE/POSITION, AGENCY"]
[null,null,null,null,null,"*If Collateral Contact is used,\nenter Contact Info:"]

{"sheet":"VERIFICATION DOCUMENTS","index":2,"n_rows":4,"n_cols":13,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,1,1,13],[3,1,3,13]]}
[]
[null,"TANF WORK HOURS VERIFICATION/DOCUMENTATION CHECKLIST\nVERIFICATION DOCUMENTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ES-4304   Rev.10/21"]
[null," Insert Verification Documents onto this page.\n\n ● Take a Screenshot.\n       - Ensure the electronic document or screenshot you want to capture is pulled up on your computer.\n       - Click on Insert tab in this Microsoft Excel document.\n       - In the Illustrations box, click on Take a Screenshot.\n       - Select the Available Window that you want to insert.  \n\n ● Capture only a portion of electronic document or screenshot.\n       - Ensure the electronic document or screenshot you want to capture is pulled up on your computer.\n       - Click on Insert tab in this Microsoft Excel document.\n       - In the Illustrations box, click on Take a Screenshot.\n       - Select Screen Clipping.  The computer screen will become gray.\n       - Use the cursor to encircle the information you want to capture in the Screenshot.\n\nYou may move and resize the Screenshot that is inserted to ensure it is readable and will stay on one page."]

{"sheet":"VOC CALCULATOR","index":3,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[[22,1,26,2],[8,1,8,2],[9,1,13,2],[1,3,1,9],[2,3,2,4],[21,1,21,2],[2,6,2,7],[19,3,19,7]]}
[null,null,null,null,null,null,null,null,null,"ES-4304   Rev. 10/21"]
[null,null,null,"Calculating Hours for Vocational Education Activity"]
[null,null,null,"Sample Month & Year",null,null,"Actual Hours Verified?"]
[null,null,null,null,{"$f":"MONTH(F3)","v":1}]
[null,null,null,null,{"$f":"DAY(F3)+IF($E$4=4,30,IF($E$4=2,28,IF($E$4=6,30,IF($E$4=9,30,IF($E$4=11,30,31)))))-1","v":30}]
[null,null,null,null,{"$f":"YEAR(TODAY())","v":2021}]
[null,null,null,null,{"$f":"DATE(E6,E4,E5)","v":"2021-01-30"}]
[null,null,null,"First Day of Class","Last Day of Class","Enrolled Classes","Scheduled Class Hours + Documented Supervised Study Time WEEKLY","Credit Hours OR Unsupervised Study Time for Each Hour of Class WEEKLY (Whichever is LEAST)","Weekly Hours ","Monthly Hours"]
[null,"CLIENT NAME\n(Last, First)",null,null,null,"CLASS 1",null,null,{"$f":"SUM(G9:H9)","v":0},{"$f":"IF($F$3<>\"\",(MAX(0,((G9+H9)/7),ROUND(((G9+H9)/7),0))*IF(AND(D9<=$F$3,E9>=$E$7),($E$7-$F$3+1),IF(AND(D9<=$F$3,E9<=$E$7),(E9-$F$3+1),IF(AND(D9>=$F$3,E9<=$E$7),(E9-D9+1),IF(AND(D9>=$F$3,E9>=$E$7),($E$7-D9+1),\"NOT OK\"))))),\"MO/YR\")","v":"MO/YR"}]
[null,{"$f":"'TANF SAMPLE'!C43","v":0},null,null,null,"CLASS 2",null,null,0,"MO/YR"]
[null,null,null,null,null,"CLASS 3",null,null,0,"MO/YR"]
[null,null,null,null,null,"CLASS 4",null,null,0,"MO/YR"]
[null,null,null,null,null,"CLASS 5",null,null,0,"MO/YR"]
[null,null,null,null,null,"CLASS 6",null,null,0,"MO/YR"]
[null,null,null,null,null,null,null,"TOTAL",{"$f":"IF(J15>0,0,SUM(I9:I14))","v":0},{"$f":"IF(OR(D9>F$3,AND(E9<$E$7,E9>$F$3)),SUM(J9:J14),IF(OR(D10>$F$3,AND(E10<$E$7,E10>$F$3)),SUM(J9:J14),IF(OR(D11>$F$3,AND(E11<$E$7,E11>$F$3)),SUM(J9:J14),IF(OR(D12>$F$3,AND(E12<$E$7,E12>$F$3)),SUM(J9:J14),IF(OR(D13>$F$3,AND(E13<$E$7,E13>$F$3)),SUM(J9:J14),IF(OR(D14>$F$3,AND(E14<$E$7,E14>$F$3)),SUM(J9:J14),0))))))","v":0}]
[]
[]
[]
[]
[null,null,null,"Actual Hours Verified?"]
[null,null,null,"First Day of Class","Last Day of Class","Enrolled Classes","Scheduled Class Hours + Documented Supervised Study Time WEEKLY","Credit Hours OR Unsupervised Study Time for Each Hour of Class WEEKLY (Whichever is LEAST)","Weekly Hours ","Monthly Hours"]
[null,"CLIENT NAME\n(Last, First)",null,null,null,"CLASS 1",null,null,{"$f":"SUM(G22:H22)","v":0},{"$f":"IF($F$3<>\"\",(MAX(0,((G22+H22)/7),ROUND(((G22+H22)/7),0))*IF(AND(D22<=$F$3,E22>=$E$7),($E$7-$F$3+1),IF(AND(D22<=$F$3,E22<=$E$7),(E22-$F$3+1),IF(AND(D22>=$F$3,E22<=$E$7),(E22-D22+1),IF(AND(D22>=$F$3,E22>=$E$7),($E$7-D22+1),\"NOT OK\"))))),\"MO/YR\")","v":"MO/YR"}]
[null,{"$f":"'TANF SAMPLE'!C108","v":0},null,null,null,"CLASS 2",null,null,0,"MO/YR"]
[null,null,null,null,null,"CLASS 3",null,null,0,"MO/YR"]
[null,null,null,null,null,"CLASS 4",null,null,0,"MO/YR"]
[null,null,null,null,null,"CLASS 5",null,null,0,"MO/YR"]
[null,null,null,null,null,"CLASS 6",null,null,0,"MO/YR"]
[null,null,null,null,null,null,null,"TOTAL",{"$f":"IF(J28>0,0,SUM(I22:I27))","v":0},{"$f":"IF(OR(D22>F$3,AND(E22<$E$7,E22>$F$3)),SUM(J22:J27),IF(OR(D23>$F$3,AND(E23<$E$7,E23>$F$3)),SUM(J22:J27),IF(OR(D24>$F$3,AND(E24<$E$7,E24>$F$3)),SUM(J22:J27),IF(OR(D25>$F$3,AND(E25<$E$7,E25>$F$3)),SUM(J22:J27),IF(OR(D26>$F$3,AND(E26<$E$7,E26>$F$3)),SUM(J22:J27),IF(OR(D27>$F$3,AND(E27<$E$7,E27>$F$3)),SUM(J22:J27),0))))))","v":0}]

{"sheet":"DATA MANAGER","index":4,"n_rows":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"COMPONENT",null,"VERIFICATION DOCUMENTS",null,null,"FREQUENCY"]
[null,null,null,null,null,null,null,null,null,null,"DATE"]
[null,"ALCOHOL & OTHER DRUG ASSESSMENT & TREATMENT",null,"COLLATERAL CONTACT *",null,null,"WEEKLY AVG",null,null,null,{"$f":"MONTH('TANF SAMPLE'!M7)","v":1}]
[null,"ASSESSMENT",null,"EVF",null,null,"MONTHLY TOTAL",null,null,null,{"$f":"DAY('TANF SAMPLE'!M7)+IF($K$6=4,30,IF($K$6=2,28,IF($K$6=6,30,IF($K$6=9,30,IF($K$6=11,30,31)))))-1","v":30}]
[null,"DISABILITY EMPLOYMENT SERVICES",null,"INCOME AMT DETAIL PAGE",null,null,null,null,null,null,{"$f":"YEAR('TANF SAMPLE'!M7)","v":1900}]
[null,"DOMESTIC VIOLENCE / SEXUAL ASSAULT",null,"PAY STUBS",null,null,null,null,null,null,{"$f":"DATE(K8,K6,K7)","v":"1900-01-30"}]
[null,"EARLY HEAD START / HEAD START",null,"PROVIDER DATABASE"]
[null,"EDUCATION DIRECTLY RELATED TO EMPLOYMENT",null,"SCHOOL RECORDS",null,null,"YES"]
[null,"EMPLOYMENT SERVICES TRACKING",null,"WORK NUMBER",null,null,"NO"]
[null,"JOB SEARCH / JOB READINESS"]
[null,"JOB SKILLS TRAINING"]
[null,"KANSAS HEALTH PROFESSION OPPORTUNITY PROGRAM",null,null,null,null,"1P"]
[null,"MENTAL HEALTH CARE",null,null,null,null,"2P"]
[null,"MENTORING",null,null,null,null,"0P"]
[null,"ON-THE-JOB TRAINING",null,"COLLATERAL CONTACT INFO"]
[null,"PHYSICAL HEALTH CARE"]
[null,"PREVENTION & PROTECTION SERVICES",null,"NAME, PHONE #, TITLE/POSITION, AGENCY"]
[null,"REFUGEE EMPLOYMENT SERVICES"]
[null,"SATISFACTORY ATTENDANCE AT SECONDARY SCHOOL OR IN A GED PROGRAM"]
[null,"SUBSIDIZED PRIVATE EMPLOYMENT",null,"PRIMARY,SECONDARY",null,null,"ZERO HOUR"]
[null,"SUBSIDIZED PUBLIC EMPLOYMENT"]
[null,"SUPERVISED COMMUNITY SERVICE",null,"EDUCATION DIRECTLY RELATED TO EMPLOYMENT",null,null,"ALCOHOL & OTHER DRUG ASSESSMENT & TREATMENT",0]
[null,"TWO-PARENT PARENT RESPONSIBLE FOR CHILD CARE",null,"JOB SKILLS TRAINING",null,null,"ASSESSMENT",0]
[null,"UNSUBSIDIZED EMPLOYMENT",null,"ON-THE-JOB TRAINING",null,null,"DISABILITY EMPLOYMENT SERVICES","ZH"]
[null,"VOCATIONAL EDUCATION",null,"SATISFACTORY ATTENDANCE AT SECONDARY SCHOOL OR IN A GED PROGRAM",null,null,"DOMESTIC VIOLENCE / SEXUAL ASSAULT","ZH"]
[null,"WORK EXPERIENCE",null,"SUBSIDIZED PRIVATE EMPLOYMENT",null,null,"EARLY HEAD START / HEAD START","ZH"]
[null,"WORK PROGRAM PENALTY",null,"SUBSIDIZED PUBLIC EMPLOYMENT",null,null,"KANSAS HEALTH PROFESSION OPPORTUNITY PROGRAM","ZH"]
[null,"WORKFORCE INVESTMENT ACT",null,"SUPERVISED COMMUNITY SERVICE",null,null,"MENTAL HEALTH CARE","ZH"]
[null,"NO ACTIVITY OPEN",null,"UNSUBSIDIZED EMPLOYMENT",null,null,"MENTORING","ZH"]
[null,null,null,"WORK EXPERIENCE",null,null,"PHYSICAL HEALTH CARE","ZH"]
[null,null,null,null,null,null,"PREVENTION & PROTECTION SERVICES","ZH"]
[null,null,null,null,null,null,"REFUGEE EMPLOYMENT SERVICES","ZH"]
[null,null,null,"JSR",null,null,"TWO-PARENT PARENT RESPONSIBLE FOR CHILD CARE","ZH"]
[null,null,null,null,null,null,"WORK PROGRAM PENALTY","ZH"]
[null,null,null,"JOB SEARCH / JOB READINESS",null,null,"WORKFORCE INVESTMENT ACT","ZH"]
[null,null,null,null,null,null,"NO ACTIVITY OPEN","ZH"]
[]
[null,null,null,"SPECIAL ACTIVITY"]
[null,null,null,null,null,null,"emp"]
[null,null,null,"SUPERVISED COMMUNITY SERVICE"]
[null,null,null,"VOCATIONAL EDUCATION",null,null,"SUBSIDIZED PRIVATE EMPLOYMENT"]
[null,null,null,"WORK EXPERIENCE",null,null,"SUBSIDIZED PUBLIC EMPLOYMENT"]
[null,null,null,null,null,null,"UNSUBSIDIZED EMPLOYMENT"]